Forecasting Sales and Income

Howard is interested in forecasting sales and income for 2022. He has created a worksheet with his base forecast and has asked you to create four scenarios. The base scenario uses an average cost of goods sold with the current 45% of sales and average expenses of 21% of gross profit. Howard would like you to create three additional scenarios. The first will change the average cost of goods to 48%. The second will change the expenses to 28% of gross profit. The last scenario Howard would like to see is a 47% cost of goods and 24% for expenses.

Use Scenarios to forecast sales and income for QuickStove.

Working with Scenarios